home *** CD-ROM | disk | FTP | other *** search
/ Platinum Plus: Home & Hobby / Platinum Plus Home and Hobby CD Explorer.ISO / programs / cdmaster / 4166.ret < prev    next >
Encoding:
Text File  |  1995-01-29  |  6.1 KB  |  131 lines
  1. {\rtf1\ansi
  2. {\fonttbl{\f0\fswiss Arial;}}
  3. {\colortbl\red0\green0\blue0;\red128\green0\blue0;\red0\green128\blue0;\red128\green128\blue0;\red0\green0\blue128;\red128\green0\blue128;\red0\green128\blue128;\red128\green128\blue128;\red192\green192\blue192;\red255\green0\blue0;\red0\green255\blue0;\red255\green255\blue0;\red0\green0\blue255;\red255\green0\blue255;\red0\green255\blue255;}
  4. {\info{\author CA-RET}{\title Report title}}
  5. {\*\vrwvern1\vrwsubn0}
  6. \paperw12240 \paperh15840 \margl1584 \margr3744 \margt0 \margb0
  7.  
  8. \sectd \linex0 \pard
  9. {\*\vrwvar {\v0 TNUM\colnum1\colnam TNUM\len7\txt}
  10. {\v1 TITLE\colnum2\colnam TITLE\len31\txt}
  11. {\v2 STAR\colnum3\colnam STAR\len31\txt}
  12. {\v3 CAT\colnum4\colnam CAT\len6\txt}
  13. {\v4 USER1\colnum5\colnam USER1\len31\txt}
  14. {\v5 USER2\colnum6\colnam USER2\len30\txt}
  15. {\v6 USER3\colnum7\colnam USER3\len6\txt}
  16. {\v7 CROSS\colnum0\colnam CROSS\len8\flt}
  17. {\v8 FLAG\colnum0\colnam FLAG\len2\txt}
  18. {\v9 US1\colnum30\colnam US1\len9\txt}
  19. {\v10 US3\colnum31\colnam US3\len6\txt}
  20. {\v11 US2\colnum32\colnam US2\len7\txt}
  21. {\v12 STMO\colnum16\colnam STMO\len11\txt}
  22. {\v13 LSF\colnum17\colnam LSF\len11\txt}
  23. {\v14 C1\colnum8\colnam C1\len8\flt}
  24. {\v15 C2\colnum9\colnam C2\len8\flt}
  25. {\v16 C3\colnum10\colnam C3\len8\flt}
  26. {\v17 C4\colnum11\colnam C4\len8\flt}
  27. {\v18 C21\colnum12\colnam C21\len8\flt}
  28. {\v19 C22\colnum13\colnam C22\len8\flt}
  29. {\v20 C23\colnum14\colnam C23\len8\flt}
  30. {\v21 C24\colnum15\colnam C24\len8\flt}
  31. {\v22 CK1TIT\colnum18\colnam CK1TIT\len9\txt}
  32. {\v23 CK1\colnum19\colnam CK1\len7\txt}
  33. {\v24 CK2\colnum20\colnam CK2\len7\txt}
  34. {\v25 CK3\colnum21\colnam CK3\len7\txt}
  35. {\v26 CK4\colnum22\colnam CK4\len7\txt}
  36. {\v27 CK21\colnum23\colnam CK21\len7\txt}
  37. {\v28 CK22\colnum24\colnam CK22\len7\txt}
  38. {\v29 CK23\colnum25\colnam CK23\len7\txt}
  39. {\v30 CK24\colnum26\colnam CK24\len7\txt}
  40. {\v31 CK2TIT\colnum27\colnam CK2TIT\len9\txt}
  41. {\v32 XORR1\colnum28\colnam XORR1\len2\txt}
  42. {\v33 XORR2\colnum29\colnam XORR2\len2\txt}
  43. {\v34 _date{\expcr12 SystemDate()}\dat}
  44. {\v35 _pagenumber{\expcr12 PageNumber()}\int}
  45. {\v36 field1{\expcr12 Trim(CK1TIT)}\txt}
  46. {\v37 field2{\expcr12 Trim(CK2TIT)}\txt}
  47. {\v38 field3{\expcr23 If(xorr1<> "X",stmo,"")}\txt}
  48. {\v39 field8{\expcr37 if(xorr1= "X",if(c1, ck1+" ", ""),"")}\txt}
  49. {\v40 field9{\expcr37 if(xorr1= "X",if(c2, ck2+" ", ""),"")}\txt}
  50. {\v41 field10{\expcr37 if(xorr1= "X",if(c3, ck3+" ", ""),"")}\txt}
  51. {\v42 field11{\expcr37 if(xorr1= "X",if(c4, ck4+" ", ""),"")}\txt}
  52. {\v43 field12{\expcr39 if(xorr2= "X",if(c21, ck21+" ", ""),"")}\txt}
  53. {\v44 field13{\expcr39 if(xorr2= "X",if(c22, ck22+" ", ""),"")}\txt}
  54. {\v45 field14{\expcr39 if(xorr2= "X",if(c23, ck23+" ", ""),"")}\txt}
  55. {\v46 field15{\expcr39 if(xorr2= "X",if(c24, ck24+" ", ""),"")}\txt}
  56. {\v47 field16{\expcr22 If(xorr2<> "X",lsf,"")}\txt}
  57. {\*\vrwqry \qrynam QUERY1\inptyp3 {\qry530  select 
  58. urint.TNUM,
  59. urint.TITLE,
  60. urint.STAR,
  61. urint.CAT,
  62. urint.USER1,
  63. urint.USER2,
  64. urint.USER3,
  65. urint.c1,
  66. urint.c2,
  67. urint.c3,
  68. urint.c4,
  69. urint.c21,
  70. urint.c22,
  71. urint.c23,
  72. urint.c24,
  73.                   urint.stmo,
  74.                   urint.lsf,
  75. cdmstr.ck1tit,
  76. cdmstr.ck1,
  77. cdmstr.ck2,
  78. cdmstr.ck3,
  79. cdmstr.ck4,
  80. cdmstr.ck21,
  81. cdmstr.ck22,
  82. cdmstr.ck23,
  83. cdmstr.ck24,
  84. cdmstr.ck2tit,
  85. cdmstr.xorr1,
  86. cdmstr.xorr2,
  87.     cdmstr.us1,
  88.                   cdmstr.us3,
  89.     cdmstr.us2
  90.  from 
  91.     urint.DBF,
  92.               cdmstr.cfg} {\map TNUM\mapcol TNUM\mapnum1}
  93. {\map TITLE\mapcol TITLE\mapnum2}
  94. {\map STAR\mapcol STAR\mapnum3}
  95. {\map CAT\mapcol CAT\mapnum4}
  96. {\map USER1\mapcol USER1\mapnum5}
  97. {\map USER2\mapcol USER2\mapnum6}
  98. {\map USER3\mapcol USER3\mapnum7}
  99. {\map CROSS\mapnum0}
  100. {\map FLAG\mapnum0}
  101. {\map US1\mapcol US1\mapnum30}
  102. {\map US3\mapcol US3\mapnum31}
  103. {\map US2\mapcol US2\mapnum32}
  104. {\map STMO\mapcol STMO\mapnum16}
  105. {\map LSF\mapcol LSF\mapnum17}
  106. {\map C1\mapcol C1\mapnum8}
  107. {\map C2\mapcol C2\mapnum9}
  108. {\map C3\mapcol C3\mapnum10}
  109. {\map C4\mapcol C4\mapnum11}
  110. {\map C21\mapcol C21\mapnum12}
  111. {\map C22\mapcol C22\mapnum13}
  112. {\map C23\mapcol C23\mapnum14}
  113. {\map C24\mapcol C24\mapnum15}
  114. {\map CK1TIT\mapcol CK1TIT\mapnum18}
  115. {\map CK1\mapcol CK1\mapnum19}
  116. {\map CK2\mapcol CK2\mapnum20}
  117. {\map CK3\mapcol CK3\mapnum21}
  118. {\map CK4\mapcol CK4\mapnum22}
  119. {\map CK21\mapcol CK21\mapnum23}
  120. {\map CK22\mapcol CK22\mapnum24}
  121. {\map CK23\mapcol CK23\mapnum25}
  122. {\map CK24\mapcol CK24\mapnum26}
  123. {\map CK2TIT\mapcol CK2TIT\mapnum27}
  124. {\map XORR1\mapcol XORR1\mapnum28}
  125. {\map XORR2\mapcol XORR2\mapnum29}
  126. }
  127. {\*\vrwsct {\BCK11760 {\sctrct288 240 15552 12000}\nstlev1 }
  128. \pard\plain\ql {\f0\fs20 }\par\pard\plain\ql {\f0\fs20 }
  129. {\*\vrwsct {\BDY4744 {\sctrct1584 0 8496 4744}\lbl \nstlev1 }
  130. \pard\plain\qr \txttrn {\*\no_blk}{\f0\fs32 {\*\varref TNUM\trmblk}}{\f0\fs32 }\par\pard\plain\ql \txttrn {\*\no_blk}{\f0\fs36 {\*\varref TITLE\trmblk}}{\f0\fs36   }\par\pard\plain\ql \txttrn {\*\no_blk}{\f0\fs12  }\par\pard\plain\ql \txttrn {\*\no_blk}{\f0\fs32 {\*\varref STAR\trmblk}}{\f0\fs32 }\par\pard\plain\ql \txttrn {\*\no_blk}{\f0\fs12 }\par\pard\plain\ql \txttrn {\*\no_blk}{\i\f0\fs28 Category:}{\f0\fs28  }{\f0\fs28 {\*\varref CAT\trmblk}}{\f0\fs28      }{\i\f0\fs28 {\*\varref US3\trmblk}}{\f0\fs28  }{\f0\fs28 {\*\varref USER3\trmblk}}{\f0\fs28 }\par\pard\plain\ql \txttrn {\*\no_blk}{\f0\fs12 }\par\pard\plain\ql \txttrn {\*\no_blk}{\i\f0\fs28 {\*\varref US1\trmblk}}{\i\f0\fs28  }{\f0\fs28 {\*\varref USER1\trmblk}}{\f0\fs28 }\par\pard\plain\ql \txttrn {\*\no_blk}{\f0\fs12 }\par\pard\plain\ql \txttrn {\*\no_blk}{\i\f0\fs28 {\*\varref US2\trmblk}}{\i\f0\fs28  }{\f0\fs28 {\*\varref USER2\trmblk}}{\f0\fs28 }\par\pard\plain\ql \txttrn {\*\no_blk}{\f0\fs12  }\par\pard\plain\ql \txttrn {\*\no_blk}{\i\f0\fs28 {\*\varref field1}}{\i\f0\fs28 :}{\f0\fs28  }{\f0\fs28 {\*\varref field3}}{\f0\fs28 {\*\varref field8}}{\f0\fs28 {\*\varref field9}}{\f0\fs28 {\*\varref field10}}{\f0\fs28 {\*\varref field11}}{\f0\fs28 }\par\pard\plain\ql \txttrn {\*\no_blk}{\i\f0\fs12  }\par\pard\plain\ql \txttrn {\*\no_blk}{\i\f0\fs28 {\*\varref field2}}{\i\f0\fs28 :}{\f0\fs28  }{\f0\fs28 {\*\varref field16}}{\f0\fs28 {\*\varref field12}}{\f0\fs28 {\*\varref field13}}{\f0\fs28 {\*\varref field14}}{\f0\fs28 {\*\varref field15}}{\f0\fs28 }
  131. }